Computer Question Bank
for Exam preparation

Q2. Ms Excel:To copy cell contents using drag and drop press the

1. End key
2. Shift key
3. Ctrl key
4. Esc key

Q3. Ms Excel:What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changed

1. Format Report
2. Pivot Table
3. Refresh Data
4. Show Detail

Q4. Ms Word: Ctrl + S

1. Save Document with different name
2. Save Document with same name
3. Save Document and Close Word Application
4. Save Document and Print whole Pages

Q5. Ms Excel:Which of the following is not true regarding Conditional Formatting?

1. You can add more than one condition to check
2. You can set condition to look for Bold and apply Italics on them.
3. You can apply Font, border and pattern formats that meets the specified conditions
4. You can delete any condition from Conditional Formatting dialog box if it is not requried

Q6. Ms Access: Which of the following statement is true

1. Reports can be used to retrieve data from tables and calculate
2. Queries can be printed in well formatted manner and presented as the information
3. Queries can include calculated fields that do not exist in table
4. Reports and forms are similar but forms are use to print but reports to display on screen only

Q7. Ms Excel:How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?

1. F8
2. F9
3. F10
4. F11

Q8. Ms Access: What are the columns in a Microsoft Access table called?

1. Rows
2. Records
3. Fields
4. Columns

Q9. The arranging of data in a logical sequence is called

1. Sorting
2. Classifying
3. Reproducing
4. Summarizing

Q10. Ms Word: Which of the following symbol sets would be most likely to contain a mathematical symbol such as a degree sign, greater than or equal to, or a Greek letter?

1. Wingdings
2. Wingdings 3
3. Webdings
4. Symbol